Diabetes data Profiling Report 3

Dataset statistics

Number of variables	84
Number of observations	53214
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	17.4 MiB
Average record size in memory	343.0 B

Variable types

BOOL	70
NUM	12
CAT	2

Warnings

`number_emergency` is highly skewed (γ1 = 27.22568857)	Skewed
`num_procedures` has 22880 (43.0%) zeros	Zeros
`number_outpatient` has 46619 (87.6%) zeros	Zeros
`number_emergency` has 49782 (93.6%) zeros	Zeros
`number_inpatient` has 47197 (88.7%) zeros	Zeros
`numchange` has 40766 (76.6%) zeros	Zeros

Reproduction

Analysis started	2020-09-15 20:20:50.864232
Analysis finished	2020-09-15 20:21:30.080002
Duration	39.22 seconds
Software version	pandas-profiling v2.9.0
Download configuration	config.yaml

admission_type_id
Real number (ℝ_≥0)

Distinct	8
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	2.128669147
Minimum	1
Maximum	8
Zeros	0
Zeros (%)	0.0%
Memory size	415.7 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	1
median	2
Q3	3
95-th percentile	6
Maximum	8
Range	7
Interquartile range (IQR)	2

Descriptive statistics

Standard deviation	1.52929783
Coefficient of variation (CV)	0.7184290861
Kurtosis	1.680947059
Mean	2.128669147
Median Absolute Deviation (MAD)	1
Skewness	1.526149567
Sum	113275
Variance	2.338751853
Monotocity	Not monotonic

Histogram with fixed size bins (bins=8)

Value	Count	Frequency (%)
1	26591	50.0%
3	10837	20.4%
2	9784	18.4%
6	3734	7.0%
5	1965	3.7%
8	279	0.5%
7	16	< 0.1%
4	8	< 0.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	26591	50.0%
2	9784	18.4%
3	10837	20.4%
4	8	< 0.1%
5	1965	3.7%

Value	Count	Frequency (%)
8	279	0.5%
7	16	< 0.1%
6	3734	7.0%
5	1965	3.7%
4	8	< 0.1%

discharge_disposition_id
Real number (ℝ_≥0)

Distinct	21
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	3.233096554
Minimum	1
Maximum	28
Zeros	0
Zeros (%)	0.0%
Memory size	415.7 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	1
median	1
Q3	3
95-th percentile	18
Maximum	28
Range	27
Interquartile range (IQR)	2

Descriptive statistics

Standard deviation	4.948578289
Coefficient of variation (CV)	1.530600218
Kurtosis	8.46417106
Mean	3.233096554
Median Absolute Deviation (MAD)	0
Skewness	2.991388402
Sum	172046
Variance	24.48842708
Monotocity	Not monotonic

Histogram with fixed size bins (bins=21)

Value	Count	Frequency (%)
1	34705	65.2%
3	6312	11.9%
6	6076	11.4%
18	1781	3.3%
2	1157	2.2%
22	943	1.8%
5	678	1.3%
25	482	0.9%
4	395	0.7%
7	313	0.6%
Other values (11)	372	0.7%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	34705	65.2%
2	1157	2.2%
3	6312	11.9%
4	395	0.7%
5	678	1.3%

Value	Count	Frequency (%)
28	48	0.1%
27	3	< 0.1%
25	482	0.9%
24	21	< 0.1%
23	203	0.4%

admission_source_id
Real number (ℝ_≥0)

Distinct	17
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	5.601740144
Minimum	1
Maximum	25
Zeros	0
Zeros (%)	0.0%
Memory size	415.7 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	1
median	7
Q3	7
95-th percentile	17
Maximum	25
Range	24
Interquartile range (IQR)	6

Descriptive statistics

Standard deviation	4.200177537
Coefficient of variation (CV)	0.7497987107
Kurtosis	1.63122976
Mean	5.601740144
Median Absolute Deviation (MAD)	0
Skewness	1.097477822
Sum	298091
Variance	17.64149134
Monotocity	Not monotonic

Histogram with fixed size bins (bins=17)

Value	Count	Frequency (%)
7	27584	51.8%
1	16758	31.5%
17	3721	7.0%
4	2173	4.1%
6	1472	2.8%
2	782	1.5%
5	402	0.8%
20	130	0.2%
3	87	0.2%
9	81	0.2%
Other values (7)	24	< 0.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	16758	31.5%
2	782	1.5%
3	87	0.2%
4	2173	4.1%
5	402	0.8%

Value	Count	Frequency (%)
25	2	< 0.1%
22	3	< 0.1%
20	130	0.2%
17	3721	7.0%
14	2	< 0.1%

time_in_hospital
Real number (ℝ_≥0)

Distinct	14
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	4.196188973
Minimum	1
Maximum	14
Zeros	0
Zeros (%)	0.0%
Memory size	415.7 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	2
median	3
Q3	6
95-th percentile	10
Maximum	14
Range	13
Interquartile range (IQR)	4

Descriptive statistics

Standard deviation	2.91533184
Coefficient of variation (CV)	0.6947570424
Kurtosis	1.125880433
Mean	4.196188973
Median Absolute Deviation (MAD)	2
Skewness	1.21542345
Sum	223296
Variance	8.499159738
Monotocity	Not monotonic

Histogram with fixed size bins (bins=14)

Value	Count	Frequency (%)
3	9568	18.0%
2	9451	17.8%
1	8390	15.8%
4	7084	13.3%
5	5001	9.4%
6	3747	7.0%
7	2848	5.4%
8	2066	3.9%
9	1376	2.6%
10	1093	2.1%
Other values (4)	2590	4.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	8390	15.8%
2	9451	17.8%
3	9568	18.0%
4	7084	13.3%
5	5001	9.4%

Value	Count	Frequency (%)
14	469	0.9%
13	574	1.1%
12	654	1.2%
11	893	1.7%
10	1093	2.1%

num_lab_procedures
Real number (ℝ_≥0)

Distinct	115
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	43.12943962
Minimum	1
Maximum	121
Zeros	0
Zeros (%)	0.0%
Memory size	415.7 KiB

Quantile statistics

Minimum	1
5-th percentile	4
Q1	31
median	44
Q3	57
95-th percentile	74
Maximum	121
Range	120
Interquartile range (IQR)	26

Descriptive statistics

Standard deviation	19.93832051
Coefficient of variation (CV)	0.4622902752
Kurtosis	-0.2967895251
Mean	43.12943962
Median Absolute Deviation (MAD)	13
Skewness	-0.2196322131
Sum	2295090
Variance	397.5366249
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	1662	3.1%
43	1359	2.6%
44	1250	2.3%
45	1187	2.2%
38	1170	2.2%
47	1148	2.2%
46	1146	2.2%
40	1130	2.1%
37	1087	2.0%
41	1073	2.0%
Other values (105)	41002	77.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	1662	3.1%
2	568	1.1%
3	383	0.7%
4	234	0.4%
5	164	0.3%

Value	Count	Frequency (%)
121	1	< 0.1%
120	1	< 0.1%
118	1	< 0.1%
114	1	< 0.1%
113	2	< 0.1%

num_procedures
Real number (ℝ_≥0)

ZEROS

Distinct	7
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	1.460386364
Minimum	0
Maximum	6
Zeros	22880
Zeros (%)	43.0%
Memory size	415.7 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	1
Q3	2
95-th percentile	6
Maximum	6
Range	6
Interquartile range (IQR)	2

Descriptive statistics

Standard deviation	1.768805094
Coefficient of variation (CV)	1.211189817
Kurtosis	0.4700768716
Mean	1.460386364
Median Absolute Deviation (MAD)	1
Skewness	1.1943098
Sum	77713
Variance	3.128671461
Monotocity	Not monotonic

Histogram with fixed size bins (bins=7)

Value	Count	Frequency (%)
0	22880	43.0%
1	10697	20.1%
2	6971	13.1%
3	5503	10.3%
6	3022	5.7%
4	2272	4.3%
5	1869	3.5%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	22880	43.0%
1	10697	20.1%
2	6971	13.1%
3	5503	10.3%
4	2272	4.3%

Value	Count	Frequency (%)
6	3022	5.7%
5	1869	3.5%
4	2272	4.3%
3	5503	10.3%
2	6971	13.1%

num_medications
Real number (ℝ_≥0)

Distinct	73
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	15.5756192
Minimum	1
Maximum	81
Zeros	0
Zeros (%)	0.0%
Memory size	415.7 KiB

Quantile statistics

Minimum	1
5-th percentile	5
Q1	10
median	14
Q3	20
95-th percentile	31
Maximum	81
Range	80
Interquartile range (IQR)	10

Descriptive statistics

Standard deviation	8.390502151
Coefficient of variation (CV)	0.5386946127
Kurtosis	3.767344485
Mean	15.5756192
Median Absolute Deviation (MAD)	5
Skewness	1.445086226
Sum	828841
Variance	70.40052634
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
12	3200	6.0%
13	3156	5.9%
11	3040	5.7%
10	2990	5.6%
14	2953	5.5%
15	2930	5.5%
9	2777	5.2%
16	2710	5.1%
8	2516	4.7%
17	2450	4.6%
Other values (63)	24492	46.0%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	181	0.3%
2	325	0.6%
3	591	1.1%
4	923	1.7%
5	1288	2.4%

Value	Count	Frequency (%)
81	1	< 0.1%
79	1	< 0.1%
75	2	< 0.1%
74	1	< 0.1%
69	2	< 0.1%

number_outpatient
Real number (ℝ_≥0)

ZEROS

Distinct	29
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	0.2658322998
Minimum	0
Maximum	36
Zeros	46619
Zeros (%)	87.6%
Memory size	415.7 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	2
Maximum	36
Range	36
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	1.019417003
Coefficient of variation (CV)	3.834812412
Kurtosis	163.6789768
Mean	0.2658322998
Median Absolute Deviation (MAD)	0
Skewness	9.167543438
Sum	14146
Variance	1.039211025
Monotocity	Not monotonic

Histogram with fixed size bins (bins=29)

Value	Count	Frequency (%)
0	46619	87.6%
1	3422	6.4%
2	1430	2.7%
3	820	1.5%
4	427	0.8%
5	203	0.4%
6	92	0.2%
7	46	0.1%
8	45	0.1%
9	27	0.1%
Other values (19)	83	0.2%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	46619	87.6%
1	3422	6.4%
2	1430	2.7%
3	820	1.5%
4	427	0.8%

Value	Count	Frequency (%)
36	1	< 0.1%
35	1	< 0.1%
33	1	< 0.1%
29	1	< 0.1%
26	1	< 0.1%

number_emergency
Real number (ℝ_≥0)

SKEWED
ZEROS

Distinct	16
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	0.09061525163
Minimum	0
Maximum	42
Zeros	49782
Zeros (%)	93.6%
Memory size	415.7 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	1
Maximum	42
Range	42
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	0.4967912989
Coefficient of variation (CV)	5.482424757
Kurtosis	1741.902071
Mean	0.09061525163
Median Absolute Deviation (MAD)	0
Skewness	27.22568857
Sum	4822
Variance	0.2468015947
Monotocity	Not monotonic

Histogram with fixed size bins (bins=16)

Value	Count	Frequency (%)
0	49782	93.6%
1	2671	5.0%
2	495	0.9%
3	154	0.3%
4	49	0.1%
5	22	< 0.1%
6	18	< 0.1%
8	6	< 0.1%
7	5	< 0.1%
10	4	< 0.1%
Other values (6)	8	< 0.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	49782	93.6%
1	2671	5.0%
2	495	0.9%
3	154	0.3%
4	49	0.1%

Value	Count	Frequency (%)
42	1	< 0.1%
37	1	< 0.1%
25	1	< 0.1%
20	1	< 0.1%
11	1	< 0.1%

number_inpatient
Real number (ℝ_≥0)

ZEROS

Distinct	13
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	0.1696546022
Minimum	0
Maximum	12
Zeros	47197
Zeros (%)	88.7%
Memory size	415.7 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	1
Maximum	12
Range	12
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	0.5882281936
Coefficient of variation (CV)	3.467210356
Kurtosis	50.67093536
Mean	0.1696546022
Median Absolute Deviation (MAD)	0
Skewness	5.711489778
Sum	9028
Variance	0.3460124077
Monotocity	Not monotonic

Histogram with fixed size bins (bins=13)

Value	Count	Frequency (%)
0	47197	88.7%
1	4248	8.0%
2	1115	2.1%
3	353	0.7%
4	167	0.3%
5	62	0.1%
6	39	0.1%
7	11	< 0.1%
8	10	< 0.1%
10	4	< 0.1%
Other values (3)	8	< 0.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	47197	88.7%
1	4248	8.0%
2	1115	2.1%
3	353	0.7%
4	167	0.3%

Value	Count	Frequency (%)
12	2	< 0.1%
11	2	< 0.1%
10	4	< 0.1%
9	4	< 0.1%
8	10	< 0.1%

number_diagnoses
Real number (ℝ_≥0)

Distinct	16
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	7.15356861
Minimum	1
Maximum	16
Zeros	0
Zeros (%)	0.0%
Memory size	415.7 KiB

Quantile statistics

Minimum	1
5-th percentile	3
Q1	5
median	8
Q3	9
95-th percentile	9
Maximum	16
Range	15
Interquartile range (IQR)	4

Descriptive statistics

Standard deviation	2.030155451
Coefficient of variation (CV)	0.2837961808
Kurtosis	-0.4392293637
Mean	7.15356861
Median Absolute Deviation (MAD)	1
Skewness	-0.6731462681
Sum	380670
Variance	4.121531154
Monotocity	Not monotonic

Histogram with fixed size bins (bins=16)

Value	Count	Frequency (%)
9	22661	42.6%
5	7068	13.3%
6	5895	11.1%
7	5652	10.6%
8	5515	10.4%
4	3542	6.7%
3	1920	3.6%
2	734	1.4%
1	174	0.3%
16	26	< 0.1%
Other values (6)	27	0.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	174	0.3%
2	734	1.4%
3	1920	3.6%
4	3542	6.7%
5	7068	13.3%

Value	Count	Frequency (%)
16	26	< 0.1%
15	5	< 0.1%
14	3	< 0.1%
13	8	< 0.1%
12	3	< 0.1%

max_glu_serum
Categorical

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	415.7 KiB

-99	50851
0	1231
1	1132

Frequencies
Length

Value	Count	Frequency (%)
-99	50851	95.6%
0	1231	2.3%
1	1132	2.1%

Frequencies of value counts

Unique

Unique	0 ?
Unique (%)	0.0%

Histogram of lengths of the category

Length

Max length	3
Median length	3
Mean length	2.911188785
Min length	1

A1Cresult
Categorical

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	415.7 KiB

-99	43216
1	7024
0	2974

Frequencies
Length

Value	Count	Frequency (%)
-99	43216	81.2%
1	7024	13.2%
0	2974	5.6%

Frequencies of value counts

Unique

Unique	0 ?
Unique (%)	0.0%

Histogram of lengths of the category

Length

Max length	3
Median length	3
Mean length	2.624234224
Min length	1

metformin
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	415.7 KiB

0	41655
1	11559

Common Values
Chart

Value	Count	Frequency (%)
0	41655	78.3%
1	11559	21.7%

repaglinide
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	415.7 KiB

0	52573
1	641

Common Values
Chart

Value	Count	Frequency (%)
0	52573	98.8%
1	641	1.2%

nateglinide
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	415.7 KiB

0	52844
1	370

Common Values
Chart

Value	Count	Frequency (%)
0	52844	99.3%
1	370	0.7%

chlorpropamide
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	415.7 KiB

0	53157
1	57

Common Values
Chart

Value	Count	Frequency (%)
0	53157	99.9%
1	57	0.1%

glimepiride
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	415.7 KiB

0	50381
1	2833

Common Values
Chart

Value	Count	Frequency (%)
0	50381	94.7%
1	2833	5.3%

acetohexamide
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	415.7 KiB

0	53213
1	1

Common Values
Chart

Value	Count	Frequency (%)
0	53213	> 99.9%
1	1	< 0.1%

glipizide
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	415.7 KiB

0	46508
1	6706

Common Values
Chart

Value	Count	Frequency (%)
0	46508	87.4%
1	6706	12.6%

glyburide
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	415.7 KiB

0	47399
1	5815

Common Values
Chart

Value	Count	Frequency (%)
0	47399	89.1%
1	5815	10.9%

tolbutamide
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	415.7 KiB

0	53199
1	15

Common Values
Chart

Value	Count	Frequency (%)
0	53199	> 99.9%
1	15	< 0.1%

pioglitazone
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	415.7 KiB

0	49213
1	4001

Common Values
Chart

Value	Count	Frequency (%)
0	49213	92.5%
1	4001	7.5%

rosiglitazone
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	415.7 KiB

0	49763
1	3451

Common Values
Chart

Value	Count	Frequency (%)
0	49763	93.5%
1	3451	6.5%

acarbose
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	415.7 KiB

0	53075
1	139

Common Values
Chart

Value	Count	Frequency (%)
0	53075	99.7%
1	139	0.3%

miglitol
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	415.7 KiB

0	53204
1	10

Common Values
Chart

Value	Count	Frequency (%)
0	53204	> 99.9%
1	10	< 0.1%

troglitazone
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	415.7 KiB

0	53212
1	2

Common Values
Chart

Value	Count	Frequency (%)
0	53212	> 99.9%
1	2	< 0.1%

tolazamide
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	415.7 KiB

0	53190
1	24

Common Values
Chart

Value	Count	Frequency (%)
0	53190	> 99.9%
1	24	< 0.1%

insulin
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	415.7 KiB

1	26712
0	26502

Common Values
Chart

Value	Count	Frequency (%)
1	26712	50.2%
0	26502	49.8%

glyburide-metformin
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	415.7 KiB

0	52853
1	361

Common Values
Chart

Value	Count	Frequency (%)
0	52853	99.3%
1	361	0.7%

glipizide-metformin
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	415.7 KiB

0	53211
1	3

Common Values
Chart

Value	Count	Frequency (%)
0	53211	> 99.9%
1	3	< 0.1%

metformin-rosiglitazone
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	415.7 KiB

0	53212
1	2

Common Values
Chart

Value	Count	Frequency (%)
0	53212	> 99.9%
1	2	< 0.1%

metformin-pioglitazone
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	415.7 KiB

0	53213
1	1

Common Values
Chart

Value	Count	Frequency (%)
0	53213	> 99.9%
1	1	< 0.1%

change
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	415.7 KiB

0	29787
1	23427

Common Values
Chart

Value	Count	Frequency (%)
0	29787	56.0%
1	23427	44.0%

diabetesMed
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	415.7 KiB

1	39995
0	13219

Common Values
Chart

Value	Count	Frequency (%)
1	39995	75.2%
0	13219	24.8%

readmitted
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	415.7 KiB

0	51061
1	2153

Common Values
Chart

Value	Count	Frequency (%)
0	51061	96.0%
1	2153	4.0%

numchange
Real number (ℝ_≥0)

ZEROS

Distinct	5
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	0.248787913
Minimum	0
Maximum	4
Zeros	40766
Zeros (%)	76.6%
Memory size	415.7 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	1
Maximum	4
Range	4
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	0.4681279296
Coefficient of variation (CV)	1.881634538
Kurtosis	2.50601288
Mean	0.248787913
Median Absolute Deviation (MAD)	0
Skewness	1.700747842
Sum	13239
Variance	0.2191437585
Monotocity	Not monotonic

Histogram with fixed size bins (bins=5)

Value	Count	Frequency (%)
0	40766	76.6%
1	11721	22.0%
2	666	1.3%
3	58	0.1%
4	3	< 0.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	40766	76.6%
1	11721	22.0%
2	666	1.3%
3	58	0.1%
4	3	< 0.1%

Value	Count	Frequency (%)
4	3	< 0.1%
3	58	0.1%
2	666	1.3%
1	11721	22.0%
0	40766	76.6%

race_Asian
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	52.0 KiB

0	52797
1	417

Common Values
Chart

Value	Count	Frequency (%)
0	52797	99.2%
1	417	0.8%

race_Caucasian
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	52.0 KiB

1	41354
0	11860

Common Values
Chart

Value	Count	Frequency (%)
1	41354	77.7%
0	11860	22.3%

race_Hispanic
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	52.0 KiB

0	52010
1	1204

Common Values
Chart

Value	Count	Frequency (%)
0	52010	97.7%
1	1204	2.3%

race_Other
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	52.0 KiB

0	52268
1	946

Common Values
Chart

Value	Count	Frequency (%)
0	52268	98.2%
1	946	1.8%

age_[10-20)
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	52.0 KiB

0	52772
1	442

Common Values
Chart

Value	Count	Frequency (%)
0	52772	99.2%
1	442	0.8%

age_[20-30)
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	52.0 KiB

0	52321
1	893

Common Values
Chart

Value	Count	Frequency (%)
0	52321	98.3%
1	893	1.7%

age_[30-40)
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	52.0 KiB

0	51079
1	2135

Common Values
Chart

Value	Count	Frequency (%)
0	51079	96.0%
1	2135	4.0%

age_[40-50)
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	52.0 KiB

0	47895
1	5319

Common Values
Chart

Value	Count	Frequency (%)
0	47895	90.0%
1	5319	10.0%

age_[50-60)
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	52.0 KiB

0	43583
1	9631

Common Values
Chart

Value	Count	Frequency (%)
0	43583	81.9%
1	9631	18.1%

age_[60-70)
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	52.0 KiB

0	41177
1	12037

Common Values
Chart

Value	Count	Frequency (%)
0	41177	77.4%
1	12037	22.6%

age_[70-80)
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	52.0 KiB

0	40058
1	13156

Common Values
Chart

Value	Count	Frequency (%)
0	40058	75.3%
1	13156	24.7%

age_[80-90)
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	52.0 KiB

0	45121
1	8093

Common Values
Chart

Value	Count	Frequency (%)
0	45121	84.8%
1	8093	15.2%

age_[90-100)
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	52.0 KiB

0	51851
1	1363

Common Values
Chart

Value	Count	Frequency (%)
0	51851	97.4%
1	1363	2.6%

medical_specialty_Emergency/Trauma
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	52.0 KiB

0	50329
1	2885

Common Values
Chart

Value	Count	Frequency (%)
0	50329	94.6%
1	2885	5.4%

medical_specialty_Family/GeneralPractice
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	52.0 KiB

0	49553
1	3661

Common Values
Chart

Value	Count	Frequency (%)
0	49553	93.1%
1	3661	6.9%

medical_specialty_Gastroenterology
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	52.0 KiB

0	52937
1	277

Common Values
Chart

Value	Count	Frequency (%)
0	52937	99.5%
1	277	0.5%

medical_specialty_InternalMedicine
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	52.0 KiB

0	44679
1	8535

Common Values
Chart

Value	Count	Frequency (%)
0	44679	84.0%
1	8535	16.0%

medical_specialty_Nephrology
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	52.0 KiB

0	52731
1	483

Common Values
Chart

Value	Count	Frequency (%)
0	52731	99.1%
1	483	0.9%

medical_specialty_ObstetricsandGynecology
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	52.0 KiB

0	52682
1	532

Common Values
Chart

Value	Count	Frequency (%)
0	52682	99.0%
1	532	1.0%

medical_specialty_Orthopedics
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	52.0 KiB

0	52341
1	873

Common Values
Chart

Value	Count	Frequency (%)
0	52341	98.4%
1	873	1.6%

medical_specialty_Orthopedics-Reconstructive
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	52.0 KiB

0	52300
1	914

Common Values
Chart

Value	Count	Frequency (%)
0	52300	98.3%
1	914	1.7%

medical_specialty_Other
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	52.0 KiB

0	51522
1	1692

Common Values
Chart

Value	Count	Frequency (%)
0	51522	96.8%
1	1692	3.2%

medical_specialty_Psychiatry
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	52.0 KiB

0	52742
1	472

Common Values
Chart

Value	Count	Frequency (%)
0	52742	99.1%
1	472	0.9%

medical_specialty_Pulmonology
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	52.0 KiB

0	52705
1	509

Common Values
Chart

Value	Count	Frequency (%)
0	52705	99.0%
1	509	1.0%

medical_specialty_Radiologist
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	52.0 KiB

0	52603
1	611

Common Values
Chart

Value	Count	Frequency (%)
0	52603	98.9%
1	611	1.1%

medical_specialty_Surgery-Cardiovascular/Thoracic
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	52.0 KiB

0	52822
1	392

Common Values
Chart

Value	Count	Frequency (%)
0	52822	99.3%
1	392	0.7%

medical_specialty_Surgery-General
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	52.0 KiB

0	51455
1	1759

Common Values
Chart

Value	Count	Frequency (%)
0	51455	96.7%
1	1759	3.3%

medical_specialty_Surgery-Neuro
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	52.0 KiB

0	52855
1	359

Common Values
Chart

Value	Count	Frequency (%)
0	52855	99.3%
1	359	0.7%

medical_specialty_Surgery-Vascular
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	52.0 KiB

0	52949
1	265

Common Values
Chart

Value	Count	Frequency (%)
0	52949	99.5%
1	265	0.5%

medical_specialty_Unknow
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	52.0 KiB

0	28043
1	25171

Common Values
Chart

Value	Count	Frequency (%)
0	28043	52.7%
1	25171	47.3%

medical_specialty_Urology
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	52.0 KiB

0	52796
1	418

Common Values
Chart

Value	Count	Frequency (%)
0	52796	99.2%
1	418	0.8%

diag_1_Diabetes
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	52.0 KiB

0	48994
1	4220

Common Values
Chart

Value	Count	Frequency (%)
0	48994	92.1%
1	4220	7.9%

diag_1_Digestive
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	52.0 KiB

0	48254
1	4960

Common Values
Chart

Value	Count	Frequency (%)
0	48254	90.7%
1	4960	9.3%

diag_1_Genitourinary
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	52.0 KiB

0	50570
1	2644

Common Values
Chart

Value	Count	Frequency (%)
0	50570	95.0%
1	2644	5.0%

diag_1_Injury
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	52.0 KiB

0	49589
1	3625

Common Values
Chart

Value	Count	Frequency (%)
0	49589	93.2%
1	3625	6.8%

diag_1_Muscoloskeletal
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	52.0 KiB

0	49891
1	3323

Common Values
Chart

Value	Count	Frequency (%)
0	49891	93.8%
1	3323	6.2%

diag_1_Neoplasms
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	52.0 KiB

0	44608
1	8606

Common Values
Chart

Value	Count	Frequency (%)
0	44608	83.8%
1	8606	16.2%

diag_1_Others
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	52.0 KiB

0	50512
1	2702

Common Values
Chart

Value	Count	Frequency (%)
0	50512	94.9%
1	2702	5.1%

diag_1_Respiratory
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	52.0 KiB

0	46170
1	7044

Common Values
Chart

Value	Count	Frequency (%)
0	46170	86.8%
1	7044	13.2%

diag_2_Diabetes
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	52.0 KiB

0	45537
1	7677

Common Values
Chart

Value	Count	Frequency (%)
0	45537	85.6%
1	7677	14.4%

diag_2_Digestive
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	52.0 KiB

0	51011
1	2203

Common Values
Chart

Value	Count	Frequency (%)
0	51011	95.9%
1	2203	4.1%

diag_2_Genitourinary
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	52.0 KiB

0	49189
1	4025

Common Values
Chart

Value	Count	Frequency (%)
0	49189	92.4%
1	4025	7.6%

diag_2_Injury
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	52.0 KiB

0	51707
1	1507

Common Values
Chart

Value	Count	Frequency (%)
0	51707	97.2%
1	1507	2.8%

diag_2_Muscoloskeletal
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	52.0 KiB

0	52181
1	1033

Common Values
Chart

Value	Count	Frequency (%)
0	52181	98.1%
1	1033	1.9%

diag_2_Neoplasms
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	52.0 KiB

0	42570
1	10644

Common Values
Chart

Value	Count	Frequency (%)
0	42570	80.0%
1	10644	20.0%

diag_2_Others
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	52.0 KiB

0	48938
1	4276

Common Values
Chart

Value	Count	Frequency (%)
0	48938	92.0%
1	4276	8.0%

diag_2_Respiratory
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	52.0 KiB

0	48045
1	5169

Common Values
Chart

Value	Count	Frequency (%)
0	48045	90.3%
1	5169	9.7%

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

Cramér's V (φc)

Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.

Count
Matrix

First rows

	admission_type_id	discharge_disposition_id	admission_source_id	time_in_hospital	num_lab_procedures	num_procedures	num_medications	number_outpatient	number_inpatient	number_diagnoses	max_glu_serum	A1Cresult	metformin	glimepiride	glipizide	glyburide	rosiglitazone	insulin	change	diabetesMed	numchange	race_Caucasian	age_[10-20)	age_[20-30)	age_[30-40)	age_[40-50)	age_[50-60)	age_[60-70)	age_[70-80)	age_[80-90)	age_[90-100)	medical_specialty_InternalMedicine	medical_specialty_Other	medical_specialty_Unknow	diag_1_Diabetes	diag_1_Neoplasms	diag_1_Others	diag_2_Diabetes	diag_2_Neoplasms	diag_2_Respiratory
0	6	25	1	1	41	0	1	0	0	1	-99	-99	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0	0	0	0	0	1	0	1	0	0	1	0	0
1	1	1	7	3	59	0	18	0	0	9	-99	-99	0	0	0	0	0	1	1	1	1	1	1	0	0	0	0	0	0	0	0	0	0	1	0	1	0	1	0	0
2	1	1	7	2	11	5	13	2	1	6	-99	-99	0	0	1	0	0	0	0	1	0	0	0	1	0	0	0	0	0	0	0	0	0	1	0	0	1	1	0	0
3	1	1	7	2	44	1	16	0	0	7	-99	-99	0	0	0	0	0	1	1	1	1	1	0	0	1	0	0	0	0	0	0	0	0	1	0	1	0	1	0	0
4	1	1	7	1	51	0	8	0	0	5	-99	-99	0	0	1	0	0	1	1	1	0	1	0	0	0	1	0	0	0	0	0	0	0	1	0	1	0	0	1	0
5	2	1	2	3	31	6	16	0	0	9	-99	-99	0	0	0	0	0	1	0	1	0	1	0	0	0	0	1	0	0	0	0	0	0	1	0	0	0	0	0	0
6	3	1	2	4	70	1	21	0	0	7	-99	-99	1	1	0	0	0	1	1	1	0	1	0	0	0	0	0	1	0	0	0	0	0	1	0	0	0	0	0	0
7	1	1	7	5	73	0	12	0	0	8	-99	-99	0	0	0	1	0	0	0	1	0	1	0	0	0	0	0	0	1	0	0	0	0	1	0	0	0	0	0	1
8	2	1	4	13	68	2	28	0	0	8	-99	-99	0	0	1	0	0	1	1	1	0	1	0	0	0	0	0	0	0	1	0	0	0	1	0	0	0	0	0	0
9	3	3	4	12	33	3	18	0	0	8	-99	-99	0	0	0	0	1	1	1	1	0	1	0	0	0	0	0	0	0	0	1	1	0	0	0	0	0	0	1	0

Last rows

	admission_type_id	discharge_disposition_id	admission_source_id	time_in_hospital	num_lab_procedures	num_procedures	num_medications	number_outpatient	number_emergency	number_inpatient	number_diagnoses	max_glu_serum	A1Cresult	metformin	glipizide	glyburide	insulin	change	diabetesMed	numchange	race_Caucasian	race_Other	age_[40-50)	age_[60-70)	age_[70-80)	age_[80-90)	medical_specialty_Orthopedics	medical_specialty_Unknow	diag_1_Diabetes	diag_1_Digestive	diag_1_Genitourinary	diag_1_Injury	diag_1_Muscoloskeletal	diag_1_Neoplasms	diag_1_Others	diag_2_Digestive	diag_2_Genitourinary	diag_2_Muscoloskeletal	diag_2_Neoplasms
53204	1	4	7	14	69	0	16	0	0	0	5	-99	1	1	0	1	1	1	1	2	1	0	1	0	0	0	0	1	0	0	0	0	0	1	0	0	0	0	1
53205	3	6	1	3	27	1	29	0	1	0	9	-99	0	1	1	0	1	1	1	0	1	0	0	0	1	0	1	0	0	0	0	0	1	0	0	0	0	0	0
53206	3	6	1	13	77	6	65	0	0	0	16	-99	0	0	0	0	1	1	1	1	1	0	0	0	1	0	0	1	0	0	0	0	0	0	0	0	0	0	0
53207	3	1	1	3	13	1	5	0	0	0	8	-99	-99	1	0	1	1	1	1	0	0	1	1	0	0	0	0	1	0	0	0	0	0	0	1	0	0	0	1
53208	1	1	7	13	51	2	13	0	0	0	9	-99	-99	1	0	0	1	1	1	1	0	1	1	0	0	0	0	1	1	0	0	0	0	0	0	0	0	1	0
53209	1	1	7	9	50	2	33	0	0	0	9	-99	1	0	0	1	1	1	1	1	1	0	0	0	1	0	0	1	0	1	0	0	0	0	0	1	0	0	0
53210	1	1	7	14	73	6	26	0	1	0	9	-99	1	0	1	0	1	1	1	1	0	1	1	0	0	0	0	1	0	0	1	0	0	0	0	0	1	0	0
53211	1	1	7	2	46	6	17	1	1	1	9	-99	-99	0	0	0	1	0	1	0	0	1	0	1	0	0	0	1	0	0	0	1	0	0	0	0	1	0	0
53212	1	1	7	5	76	1	22	0	1	0	9	-99	-99	0	0	0	1	1	1	1	1	0	0	0	0	1	0	1	0	0	0	0	0	1	0	0	0	0	1
53213	1	1	7	6	13	3	3	0	0	0	9	-99	-99	0	0	0	0	0	0	0	1	0	0	0	1	0	0	1	0	1	0	0	0	0	0	1	0	0	0

Overview

Variables

Interactions

Correlations

Pearson's r

Spearman's ρ

Kendall's τ

Phik (φk)

Cramér's V (φc)

Missing values

Sample

First rows

Last rows

	admission_type_id	discharge_disposition_id	admission_source_id	time_in_hospital	num_lab_procedures	num_procedures	num_medications	number_outpatient	number_inpatient	number_diagnoses	max_glu_serum	A1Cresult	metformin	glimepiride	glipizide	glyburide	rosiglitazone	insulin	change	diabetesMed	numchange	race_Caucasian	age_[10-20)	age_[20-30)	age_[30-40)	age_[40-50)	age_[50-60)	age_[60-70)	age_[70-80)	age_[80-90)	age_[90-100)	medical_specialty_InternalMedicine	medical_specialty_Other	medical_specialty_Unknow	diag_1_Diabetes	diag_1_Neoplasms	diag_1_Others	diag_2_Diabetes	diag_2_Neoplasms	diag_2_Respiratory
0	6	25	1	1	41	0	1	0	0	1	-99	-99	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0	0	0	0	0	1	0	1	0	0	1	0	0
1	1	1	7	3	59	0	18	0	0	9	-99	-99	0	0	0	0	0	1	1	1	1	1	1	0	0	0	0	0	0	0	0	0	0	1	0	1	0	1	0	0
2	1	1	7	2	11	5	13	2	1	6	-99	-99	0	0	1	0	0	0	0	1	0	0	0	1	0	0	0	0	0	0	0	0	0	1	0	0	1	1	0	0
3	1	1	7	2	44	1	16	0	0	7	-99	-99	0	0	0	0	0	1	1	1	1	1	0	0	1	0	0	0	0	0	0	0	0	1	0	1	0	1	0	0
4	1	1	7	1	51	0	8	0	0	5	-99	-99	0	0	1	0	0	1	1	1	0	1	0	0	0	1	0	0	0	0	0	0	0	1	0	1	0	0	1	0
5	2	1	2	3	31	6	16	0	0	9	-99	-99	0	0	0	0	0	1	0	1	0	1	0	0	0	0	1	0	0	0	0	0	0	1	0	0	0	0	0	0
6	3	1	2	4	70	1	21	0	0	7	-99	-99	1	1	0	0	0	1	1	1	0	1	0	0	0	0	0	1	0	0	0	0	0	1	0	0	0	0	0	0
7	1	1	7	5	73	0	12	0	0	8	-99	-99	0	0	0	1	0	0	0	1	0	1	0	0	0	0	0	0	1	0	0	0	0	1	0	0	0	0	0	1
8	2	1	4	13	68	2	28	0	0	8	-99	-99	0	0	1	0	0	1	1	1	0	1	0	0	0	0	0	0	0	1	0	0	0	1	0	0	0	0	0	0
9	3	3	4	12	33	3	18	0	0	8	-99	-99	0	0	0	0	1	1	1	1	0	1	0	0	0	0	0	0	0	0	1	1	0	0	0	0	0	0	1	0

	admission_type_id	discharge_disposition_id	admission_source_id	time_in_hospital	num_lab_procedures	num_procedures	num_medications	number_outpatient	number_inpatient	number_diagnoses	max_glu_serum	A1Cresult	metformin	glimepiride	glipizide	glyburide	rosiglitazone	insulin	change	diabetesMed	numchange	race_Caucasian	age_[10-20)	age_[20-30)	age_[30-40)	age_[40-50)	age_[50-60)	age_[60-70)	age_[70-80)	age_[80-90)	age_[90-100)	medical_specialty_InternalMedicine	medical_specialty_Other	medical_specialty_Unknow	diag_1_Diabetes	diag_1_Neoplasms	diag_1_Others	diag_2_Diabetes	diag_2_Neoplasms	diag_2_Respiratory
0	6	25	1	1	41	0	1	0	0	1	-99	-99	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0	0	0	0	0	1	0	1	0	0	1	0	0
1	1	1	7	3	59	0	18	0	0	9	-99	-99	0	0	0	0	0	1	1	1	1	1	1	0	0	0	0	0	0	0	0	0	0	1	0	1	0	1	0	0
2	1	1	7	2	11	5	13	2	1	6	-99	-99	0	0	1	0	0	0	0	1	0	0	0	1	0	0	0	0	0	0	0	0	0	1	0	0	1	1	0	0
3	1	1	7	2	44	1	16	0	0	7	-99	-99	0	0	0	0	0	1	1	1	1	1	0	0	1	0	0	0	0	0	0	0	0	1	0	1	0	1	0	0
4	1	1	7	1	51	0	8	0	0	5	-99	-99	0	0	1	0	0	1	1	1	0	1	0	0	0	1	0	0	0	0	0	0	0	1	0	1	0	0	1	0
5	2	1	2	3	31	6	16	0	0	9	-99	-99	0	0	0	0	0	1	0	1	0	1	0	0	0	0	1	0	0	0	0	0	0	1	0	0	0	0	0	0
6	3	1	2	4	70	1	21	0	0	7	-99	-99	1	1	0	0	0	1	1	1	0	1	0	0	0	0	0	1	0	0	0	0	0	1	0	0	0	0	0	0
7	1	1	7	5	73	0	12	0	0	8	-99	-99	0	0	0	1	0	0	0	1	0	1	0	0	0	0	0	0	1	0	0	0	0	1	0	0	0	0	0	1
8	2	1	4	13	68	2	28	0	0	8	-99	-99	0	0	1	0	0	1	1	1	0	1	0	0	0	0	0	0	0	1	0	0	0	1	0	0	0	0	0	0
9	3	3	4	12	33	3	18	0	0	8	-99	-99	0	0	0	0	1	1	1	1	0	1	0	0	0	0	0	0	0	0	1	1	0	0	0	0	0	0	1	0

	admission_type_id	discharge_disposition_id	admission_source_id	time_in_hospital	num_lab_procedures	num_procedures	num_medications	number_outpatient	number_inpatient	number_diagnoses	max_glu_serum	A1Cresult	metformin	glimepiride	glipizide	glyburide	rosiglitazone	insulin	change	diabetesMed	numchange	race_Caucasian	age_[10-20)	age_[20-30)	age_[30-40)	age_[40-50)	age_[50-60)	age_[60-70)	age_[70-80)	age_[80-90)	age_[90-100)	medical_specialty_InternalMedicine	medical_specialty_Other	medical_specialty_Unknow	diag_1_Diabetes	diag_1_Neoplasms	diag_1_Others	diag_2_Diabetes	diag_2_Neoplasms	diag_2_Respiratory
0	6	25	1	1	41	0	1	0	0	1	-99	-99	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0	0	0	0	0	1	0	1	0	0	1	0	0
1	1	1	7	3	59	0	18	0	0	9	-99	-99	0	0	0	0	0	1	1	1	1	1	1	0	0	0	0	0	0	0	0	0	0	1	0	1	0	1	0	0
2	1	1	7	2	11	5	13	2	1	6	-99	-99	0	0	1	0	0	0	0	1	0	0	0	1	0	0	0	0	0	0	0	0	0	1	0	0	1	1	0	0
3	1	1	7	2	44	1	16	0	0	7	-99	-99	0	0	0	0	0	1	1	1	1	1	0	0	1	0	0	0	0	0	0	0	0	1	0	1	0	1	0	0
4	1	1	7	1	51	0	8	0	0	5	-99	-99	0	0	1	0	0	1	1	1	0	1	0	0	0	1	0	0	0	0	0	0	0	1	0	1	0	0	1	0
5	2	1	2	3	31	6	16	0	0	9	-99	-99	0	0	0	0	0	1	0	1	0	1	0	0	0	0	1	0	0	0	0	0	0	1	0	0	0	0	0	0
6	3	1	2	4	70	1	21	0	0	7	-99	-99	1	1	0	0	0	1	1	1	0	1	0	0	0	0	0	1	0	0	0	0	0	1	0	0	0	0	0	0
7	1	1	7	5	73	0	12	0	0	8	-99	-99	0	0	0	1	0	0	0	1	0	1	0	0	0	0	0	0	1	0	0	0	0	1	0	0	0	0	0	1
8	2	1	4	13	68	2	28	0	0	8	-99	-99	0	0	1	0	0	1	1	1	0	1	0	0	0	0	0	0	0	1	0	0	0	1	0	0	0	0	0	0
9	3	3	4	12	33	3	18	0	0	8	-99	-99	0	0	0	0	1	1	1	1	0	1	0	0	0	0	0	0	0	0	1	1	0	0	0	0	0	0	1	0